SQL Select query with a predefined last entry

The task was to create a SELECT query on a table with titles grouped alphabetically by name, but a certain name must (if found) always stay at the end.
This is like the selecting of categories on ebay.com where the categories are arranged by name but the category “Other” must have the last place.
The solution [...]