• Just add an ORDER BY clause:

    select *

    from customer

    where C_recid in (50200,50194,50430,50191,1)

    order by C_recid

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **