SELECT s1, s2,
         CASE lang
           WHEN 'es' THEN 0
           WHEN 'de' THEN 1
           ....
           ELSE 1000
         END AS lang_priority
    FROM ...
ORDER BY lang_priority;