How does ORDER BY FIELD() in MySQL work internally

/how-does-order-by-field-in-mysql-work-i