Colin-J-S wrote: … upload a photo to FB for eg the order is reversed as shown in the 2 photos I attached.
I get that. But in either case, for me, the newest are first, whether that's on top or bottom. From your screenshots, it looks like that's exactly the case for you.

Like this example of an upload in Safai, the most recent pictures appear first, and they are at the top. So the only change is that you have to scroll a different direction to get to old pictures, is that right? That can't be changed.
As a side note, I dont use 'albums' to store any photos...the photos I have are almost all regularly deleted and replaced with new...
Frankly, one of the most powerful features of Photos is its organization features, like albums, folders, searches, and so forth. But I see that you have no use for those. In that case, you could just put picture files in Finder folders and use an app like Preview to handle them. For that kind of stuff, like editing and arranging example screenshots like above, I actually use the app GraphicConverter ($40,) because it's very versatile, and I've used it for thirty years! But anything you do that's different requires practice, of course, so it may not be worth it to switch. So this is more example than suggestion!