mysqlのorder by fieldで指定のID順に並べる

 select *

  from icons
 where id in(4, 5, 6)
 order by field(id, 5, 4, 6)

=>
mysql> select * from icons where id in(4, 5, 6) order by field(id, 5, 4, 6);