Non-adiabatic approximation for resonant multiphoton excitation of vibrational-rotational states in strong laser fields