Stochastic Multi-armed Bandits: Optimal Trade-off among Optimality, Consistency, and Tail Risk