How to sort the FK dropdown menu by 'id', not by 'name' ?

I have a table ('main'), one of whose fields ('staff_id') refers to another table ('staff'). The dropdown menu from the 'staff' table is sorted by the 'staff_name' field, but I prefer it to be sorted by the "id" field. How to do it? Thank you!

How to change the "...ORDER BY staff_name..." to "...ORDER BY id..." from this query":

SELECTid, LEFT(staff_name, 256) FROMtest2.staffGROUP BYid,staff_nameORDER BYstaff_nameLIMIT 10000;

???

HeidiSQL takes the first text/varchar column for sorting, and you cannot change this behaviour.

I am planning to replace that dropdown editor with a dialog supporting features like sorting, filtering and more. See issue #762 for updates.