SELECT *
FROM Parada
WHERE Cod_Parada =  (SELECT Cod_Parada, MAX(Orden)
                 FROM Circuito
             WHERE (Nro_Linea = '149' AND Ida_Vuelta = 'I'));