DOC: clarify default behavior for categories ordering
- [x] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`

Just a doc clarification on default categories ordering, which can be pretty confusing when handling mixed dtypes (see also #22080 ).