Sort certain values to the top

To get the searched-for country first, and the remainder alphabetically:

SELECT * 
FROM   stores 
ORDER BY country = 'us' DESC, country ASC

Try this:

SELECT * FROM stores ORDER BY country = "us" DESC,  storeId

You have to link each value of a country with a numeric, with a case :

select *
from stores
order by case when country = "us" then 1
              else 0
         end desc

Related