[Housekeeping]: Update pre-commit hooks

### Proposed Changes

Update the versions of the following pre-commit hooks:

- `pre-commit-hooks`
- `isort`
- `black`
- `add-trailing-comma`
- `flake8`
- `pyupgrade`
- `yamllint`
- `interrogate`
- `markdownlint-cli`
- `ruff-pre-commit`

### Justification

This update follows the latest best practices and adds support for newer language features.