Ordering mysql results by certain field value first

I needed to order a mysql result but in a somewhat custom way.

Say there is a field "id" and rows of values of 8, 4, 2, and 19.


SELECT `id` FROM `table_name` ORDER BY `id`;


This would obviously return the order: 2,4,8,19.

But what if you needed the 4 to be first and then order by integers?


SELECT IF(`id` = '4','0','1') AS `custom_order` FROM `table_name` ORDER BY `custom_order`;


This would return 4,2,8,19.

Simple and can be really helpful.