ENUM values are sorted based on their index numbers, which depend on the order in which the enumeration members were listed in the column specification. For example, 'b' sorts before 'a' for ENUM('b', 'a')
So the following SELECT result is expected:
CREATE TABLE `colors` (
`color` ENUM('white', 'blue', 'yellow', 'orange')
);