docs changes about limitations with hook function ordering

[jack-zj-liu]

This PR is to address the issue in https://github.com/pytest-dev/pytest/issues/11307.

Approach 2 is taken, where a link to the limitations is added to hook function ordering, so users will be aware of the limitations even when not declaring new hooks. The limitations were previously only in the Declaring New Hooks section.

[obestwalter]

@jack-zj-liu would you like to address the requested changes or shall we close this to be picked up at a later time?