Photos in Apple Photos are shown in different sorting order than in Apple Finder (Sonoma 14.7.1). Apple Finder shows them in chronologically correct order, not Apple Photos.
All photos contain the correct DateTimeOriginal according to EXIFTOOL and creation date according to Apple Finder and Windows Explorer. Photos in Apple Finder are sorted by file name, which corresponds to creation date. Photos in Apple Photos are sorted by title.
Sorting is correct in Apple Finder and consistent with Windows Explorer, but not in Apple Photos.
I have read many contributions in the community. Some write that this is a known problem and has not been fixed by Apple for a long time. Other contributors suggest solutions, but these do not offer any results. See screenshots.
Question: is there a solution to this problem?
Mac Studio