When saving queries in a metabase folder and ordering by name, 1-9 is respected but 10+ is not ordered correctly

[aarthi-subramanian]

Describe the bug

• When saving queries in a metabase folder and ordering the files by name (the default sort order), 1-9 is respected but 10+ is not ordered correctly.
• E.g. if i name 10 files as 1. something, 2. something, 3. something ... 10. something.
  • The expected order of files is: 1. something, 2. something, 3. something ... 10. something
  • However the actual order is showing as: 10. something, 1. something, 2. something, 3. something ...
• This is wrong and confusing for users. I want the the sort order to be respected, especially if the sort order default is name ascending!

To Reproduce

See above

Expected behavior

See above

Logs

No response

Information about your Metabase installation

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.22+7",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.22",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.22+7",
    "os.name": "Linux",
    "os.version": "5.10.215-203.850.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "snowflake",
      "redshift"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.7"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.6.0"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-03-04",
      "tag": "v0.48.8",
      "hash": "a900c85"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Severity

Annoying

Additional context

No response