Documentation for "`only/except: merge-requests` for merge request pipelines"

What does this MR do?

This is a documentation change about https://gitlab.com/gitlab-org/gitlab-ce/issues/15310.

• CE: Here
• EE: https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/8652

Related issues

Closes https://gitlab.com/gitlab-org/gitlab-ce/issues/15310 https://gitlab.com/gitlab-org/gitlab-ce/issues/54511

Author's checklist

• Apply the correct labels and milestone
• Crosslink the document from the higher-level index
• Crosslink the document from other subject-related docs
• Correctly apply the product badges and tiers
• Port the MR to EE (or backport from CE): always recommended, required when the ee-compat-check job fails

Review checklist

• Your team's review (required)
• PM's review (recommended, but not a blocker)
• Technical writer's review (required)
• Merge the EE-MR first, CE-MR afterwards => https://gitlab.com/gitlab-org/gitlab-ee/merge_requests/8652

/label ~Documentation