Is it possible to sort with conditions?

Question

SQL Server

Hello!
Is it possible to sort with conditions so that if there is a value equal to A, ASC is sorted, and if B is sorted DESC?
For example something like this:

select Id, Category, Name
from dbo.Products
order by Category, case when Category = 'new' then Id desc else id asc end

Answer 1

select Id, Category, Name
from dbo.Products
order by Category, case when Category = 'new' then Id * -1 else id end