Why does this SQL OFFSET get slower with every page?

Why does this SQL OFFSET get slower with every page. The SQL code uses OFFSET for pagination. In MySQL OFFSET forces a full scan and skip. In SQL page 10000 can take minutes.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqloffset #sqlpagination #sqlkeyset #sqlscaling

https://www.youtube.com/watch?v=LmfRuHBSCV4