aamonkey, although your code works, it relies on a quirk of mysql whereby an equality comparison, which evaluates true or false, is interpreted as 1 or 0
i think for the benefit of simplicity and clarity, an explicit CASE expression, which is standard SQL and will work in any database system, is better --
BY CASE WHEN name = 'Other'
THEN 1 -- last
ELSE 0 -- first
, name ASC