Enhanced second-harmonic generation by counter-propagating guided optical waves