MySQL查询in操作，查询结果按in顺序显示

select * from table where id IN (3,6,9,1,2,5,8,7) order by field(id,3,6,9,1,2,5,8,7);