compaction: Extend max_collectible_offset check to adjacent compaction

[bharathv]

Cover letter

Makes sure adjacent compaction honors max_collectible_offset check added in #5318. This is critical for transactions as we do not want to compact beyond LSO.

Fixes #6335

Backport Required

• [ ] not a bug fix
• [x] issue does not exist in previous branches
• [ ] papercut/not impactful enough to backport
• [ ] v22.2.x
• [ ] v22.1.x
• [ ] v21.11.x

UX changes

• none

Release notes

• none

Features

• none

Improvements

• none