How to Keep Order From Select In Query in MySQL

When you are using select in query in mysql, if you want query result to keeps order by in, you can do like this:

For example:

If you plan to select books that book id in (2,7,4,5,6),

select * from book where book_id in  (2,7,4,5,6)  order by field(book_id,(2,7,4,5,6))