Order the trips by duration, ascending.
select * from trip order by duration
Limit it to the ids.
select id from trip order by duration
Limit it to the shortest duration.
select id from trip order by duration limit 1