我想你可能正在寻找函数 FIELD -- 虽然通常被认为是一个字符串函数，但它也适用于数字！

I think you may be looking for function FIELD -- while normally thought of as a string function, it works fine for numbers, too!

ORDER BY FIELD(field_name, 3,2,5,7,8,1)