I guess I could do

select * from table2 order by field( id, 3, 4 ) desc limit 2;

but isn't there a way to do that in the where clause?