Bug in loc not ordering rhs correctly for mixed indexer
- [x] closes #40480
- [x] tests added / passed
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them


looks fine. is this a user facing change or only a patch on AM?

also merge master  This is a regression on master, so not user facing is the array manager failure related? Sorry, did not scroll down up enough the last time.

This fixes part of the array manager bug, but not the overwriting, so adjusted the test accordingly great thanks @phofl 