Before we can implement #1097, we need to implement a pruning mechanism in the codebase to facilitate pruning of blocks and block results based on a combination of the application's retain height and the retain heights set by a data companion. The implementation must follow the logic outlined in ADR-101.

This can be implemented independently of #1097 on main and be backported to v0.38.x and v0.37.x.

### Tasks
- [ ] https://github.com/cometbft/cometbft/pull/1150