Photos always listed as most recent
I use an app extension called ViewExif to look at the metadata.

https://apps.apple.com/us/app/viewexif/id945320815

If you have a date problem, those photos could be dated September 2021 and will be the newest until that date passes. That seems to be the easiest explanation. If not, then you’ll need to review the database - fix options with Apple or reset your library that stores the ordering of photos.
I would start with checking that the dates aren’t just not what you expect. It’s often a lot easier to change dates - look at this on the Mac Photos app if you can sync via iCloud or perhaps enable iCloud and use the web page to check as well.