fix: avoid possible truncation by using `i64` for pagination offset

[mikemadden42]

• Changed the type of offset from i32 to i64 to prevent potential data loss when casting from i64 to i32.
• This change ensures that the pagination offset can handle large values without risk of truncation.
• Updated the relevant code sections to accommodate this change.