Fixed bug: Dataframe.sort_values not raising ValueError for ascending-incompatible value and Series.sort_values raising ValueError for int value
- [x] closes #41634
- [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
- [x] whatsnew entry

Apologies for any issues/mistakes. This is my first ever pull request to open source community. **Thanks for the review @phofl.**
All the comments are addressed. Hi @attack68, what are your thoughts on previous comment of mine? if it looks good, is it good to merge? thanks @gaikwadrahul20  Thanks a lot @jreback.