MAINT: update pip constraints and pre-commit

[pre-commit-ci[bot]]

updates:

• github.com/psf/black: 23.7.0 → 23.9.1
• github.com/python-jsonschema/check-jsonschema: 0.24.1 → 0.27.0
• github.com/streetsidesoftware/cspell-cli: v7.0.1 → v7.3.1
• github.com/pre-commit/mirrors-prettier: v3.0.2 → v3.0.3
• github.com/ComPWA/mirrors-pyright: v1.1.324 → v1.1.329
• github.com/asottile/pyupgrade: v3.10.1 → v3.14.0
• github.com/astral-sh/ruff-pre-commit: v0.0.285 → v0.0.292

[redeboer]

Closed by #314