Postgres can apply a custom collation via ICU that performs a "natural sort" so numbers within the text are treated as atomic units for sorting purposes. Basically a value like "B9" would sort before "B10" using natural sort (but not a traditional character-by-character sort).