BUG: Disallow non-increasing multi-index header arguments
- [x] closes #47011 (Replace xxxx with the Github issue number)
- [x] [Tests added and passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#writing-tests) if fixing a bug or adding a new feature
- [x] All [code checks passed](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#pre-commit).
- NA - Added [type annotations](https://pandas.pydata.org/pandas-docs/dev/development/contributing_codebase.html#type-hints) to new arguments/methods/functions.
- [x] Added an entry in the latest `doc/source/whatsnew/vX.X.X.rst` file if fixing a bug or adding a new feature.

I didn't add separate tests for read_excel, read_html, or read_fwf because they all pass their data to TextParser, where the header validation occurs. Let me know if you'd like separate tests for those.
> I didn't add separate tests for read_excel, read_html, or read_fwf because they all pass their data to TextParser, where the header validation occurs. Let me know if you'd like separate tests for those.

If you could find if these are already tested, please reference them in this issue. Otherwise would be good to add test for these