Sharp Concentration Inequalities: Phase Transition and Mixing of Orlicz Tails with Variance