'Order by numbers desc then by letters asc

I have a varchar column and the current order is like this:

select name from table order by name

1value
2value
3value
Avalue
Bvalue
Cvalue

I want to order first by numbers desc and then by letters asc:

3value
2value
1value
Avalue
Bvalue
Cvalue

How can I do this?

sql-server

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source