ORDER BY varchar with [a-9] instead of [0-Z] in SQL

By default, SQL orders numbers before characters.

So if I have the column "name":

abc
ab1
a1b
1ba
1bac
b21

Since SQL sorts by 0-Z (first 0 to 9, then a-Z), the query

SELECT * FROM ... ORDER BY name

will result in:

1ba
1bac
a1b
ab1
abc
abc1
b21

But I want it to sort by a-0 (first a-Z, then 0-9).

abc
abc1
ab1
a1b
b21
1ba
1bac

How do I do this in a query? More specifically, how do I do this in SQLite?

I found one solution in Sort MySQL results alphabetically, but with numbers last, but only for first char.