Agreed. I posted about this too. It's been the same FOREVER and now they bork it? Man this update is rough.
That has always been the problem with the way that operating systems sort 'alphabetically'.
Numbers (1,2,3,...) precede alphabet characters (a,b,c...) in a sort order, and the first character of a filename always takes precedence before the OS 'looks' at the second character of a filename.
The result- An 'Alphabetic' sort will be- 1, 10, 100,.., 2, 20, 200,.., 3, 30,..., 4, etc.
If you want filename prefix 'number' characters to sort "numerically" then you must precede the numbers with appropriate zeros- 0001,0002, 0003, 0010, 0020, 0100, 0200, 9999, etc.
It's not always been the case as I have been filing like this for about 10 - 15 years and the switch to 1, 10, 100, 11 ...., 2, 20, only arose yesterday when I upgraded to Adobe 2023. Up until then 2022.10.22 came after 2022.9.12 etc.
The mentioned issue is fixed in the latest patch release #188.8.131.523. Please install and confirm if that fixes the issue.
You can refer to the issues fixed in the patch at the following link https://helpx.adobe.com/bridge/kb/fixed-issues.html
It's really fixed!!! Thank you