Sort function in code not the same as clicking sort button on table

[sawft99]

I have some files and folder that look something like this:

• MyStuff/Chapter1/a1.md
• MyStuff/Chapter1/a2.md
• MyStuff/Chapter2/a1.md
• MyStuff/Chapter2/a2.md
• MyStuff/Chapter3/a1.md
• MyStuff/Chapter3/a2.md
• MyStuff/Chapter10/a1.md
• MyStuff/Chapter10/a2.md
• MyStuff/Chapter11/a1.md
• MyStuff/Chapter11/a2.md

I'm trying to make a sort of table of contents and my code looks like this

TABLE file.path as "Folder"
From "MyStuff" Where contains(file.path, "Chapter")
SORT file.path asc

So it creates a table with the folder header next to the files one. Now when I leave the code as is, I'll get a table/list like:

• MyStuff/Chapter1/a1.md
• MyStuff/Chapter1/a2.md
• MyStuff/Chapter10/a1.md
• MyStuff/Chapter10/a2.md
• MyStuff/Chapter11/a1.md
• MyStuff/Chapter11/a2.md
• MyStuff/Chapter2/a1.md
• MyStuff/Chapter2/a2.md
• MyStuff/Chapter3/a1.md
• MyStuff/Chapter3/a2.md

However, if I click the the folder column that gets rendered, it changes the sort order to a proper 1 - 10 order. Any ideas how I can get it to go 1 - 10 properly in the code instead of 1,10,11,2,3?