Transition from pulled to pushed fronts in premixed turbulent combustion: Theoretical and numerical study