Diogo,
O select da aplicação é esse com o ORDER BY pela HORAI
SELECT
gm.Idaut AS IDIDA,
gm.IdGuia AS GIDA,
DATE_FORMAT(gm.Data,'%d/%m/%Y') as DATAI,
gm.Viagem as ViagensI,
gm.Turma as TURMAI,
gm.Idcarro as CARROI,
gm.IdLinha as LINHAI ,
gm.Sentido as IDA,
DATE_FORMAT(gm.HoraSaida,'%H:%i') as SAIDAI,
DATE_FORMAT(gm.HoraChegada,'%H:%i')as CHEGADAI,
DATE_FORMAT(gm.Tempo,'%H:%i') as TEMPOI,
gm.Passageiros as PAXI,
(SELECT gm1.Idaut FROM guiasmov gm1 where gm1.Idaut < gm.Idaut order by gm.Idaut DESC limit 0,1) AS ID2,
(SELECT TIMEDIFF(DATE_FORMAT(gm.HoraSaida,'%H:%i'),DATE_FORMAT(HoraSaida,'%H:%i')) FROM guiasmov where Idaut = Id2) AS INTERVALOIDA
FROM guiasmov gm
WHERE
gm.Data = '2009-09-01' AND
gm.Idcarro Between 100 AND 130 AND
gm.Idlinha = 13
AND gm.Sentido = 0
ORDER BY
SAIDAI
E o resultado esse:
"IDIDA""GIDA""DATAI""ViagensI""TURMAI""CARROI""LINHAI""IDA""SAIDAI""CHEGADAI""TEMPOI""PAXI""ID2""INTERVALOIDA"
198495 63413 01/09/2009 1 1 104 13 0 03:58 10:03 06:05 291 198494 -15:32:00
198731 63457 01/09/2009 1 1 128 13 0 04:08 05:08 01:00 12 198730 -17:27:00
198620 63432 01/09/2009 1 1 114 13 0 04:30 05:29 00:59 17 198619 -18:19:00
198581 63425 01/09/2009 1 1 111 13 0 04:32 05:32 01:00 39 198580 -09:12:00
198705 63453 01/09/2009 1 1 126 13 0 05:21 06:16 00:55 48 198704 -16:55:00
198485 63411 01/09/2009 1 1 103 13 0 05:41 06:32 00:51 51 198484 -15:18:00
198733 63457 01/09/2009 2 1 128 13 0 06:01 07:14 01:13 56 198732 00:53:00
198699 63451 01/09/2009 1 1 125 13 0 06:27 09:20 02:53 194 198698 -09:57:00