feat: [Validation] add `required_if` rule

[warcooft]

Description Supersedes #9018

Checklist:

• [x] Securely signed commits
• [x] Component(s) with PHPDoc blocks, only if necessary or adds value
• [ ] Unit testing, with >80% coverage
• [x] User guide updated
• [x] Conforms to style guide