ORDER BY status ASC; will return 1,2,3,4.
ORDER BY status DESC; will return 4,3,2,1.
ORDER BY FIELD(status, 3, 2, 4, 1);