Sort by Surname

ORDER BY SUBSTRING_INDEX(full_name, ' ', -1)