The easiest way I can think of is to use a helper column where you write the titles as you intend to sort them, ie:
2 Guns --> Two Guns
16 Blocks --> Sixteen Blocks
8 Miles --> Eight Miles
Star Trek 1 --> Star Trek 01
Any VBA solution should indentify the numbers, and then replace by the correspondent words/letters or adding 0(s)... too much work since there can be movies that have a year (4 numbers) on their title, or even 5 (ie: 10.000 B.C.).
As I said, copy the name column to the helper column, then filter the ones with numbers, and re-write them correctly according to your needs... You only have to do it once, and also for every new title you add afterwards.