It can be done as follows:-

SELECT * FROM table_name ORDER BY FIELD(filed_name,"value_y","value_x") DESC