Add a new column to the table named "position". Anyway, the name can be anything else you want.
For ID 100, save the "position" column to 1, leave the column as 0 or null.
So when you look up, just sort by the "position" column in descending order with priority over the other sorting rules.
select id,nome from CATEGORIA ORDER BY position DESC, nome ASC;
Be aware that this does not mean that it is the best or the only solution.
I particularly prefer this way compared to other suggestions presented as it makes it more flexible. Think about when you need to assign priority to a different ID or when you want to reuse the routine for other things. You will have to change the code manually and make different adjustments and adaptations.