Add offset pagination optimization docs
What does this MR do and why?
This MR adds docs to the Gitlab::Pagination::Offset::PaginationWithIndexOnlyScan
class.
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.