SELECT -- We NEVER use SELECT *
first_name,
last_name,
country
FROM
Table1
WHERE
first_name = 'John' OR
last_name = 'Smith' OR
country = 'US'
ORDER BY
CASE WHEN first_name = 'John' THEN 0 ELSE 1 END,
CASE WHEN last_name = 'Smith' THEN 0 ELSE 1 END,
CASE WHEN country = 'US' THEN 0 ELSE 1 END