SELECT *,
    (name IN ('František', 'Áron', 'Kopecký')) AS nameFound,
    (surname IN ('František', 'Áron', 'Kopecký')) AS surnameFound
FROM people
ORDER BY (nameFound = 1 AND surnameFound = 1) DESC, surnameFound DESC
GROUP BY id
HAVING nameFound = 1 OR surnameFound = 1