import sqlite3

with sqlite3.connect(":memory:") as db:
    db.execute("CREATE TABLE bai(id INTEGER PRIMARY KEY, moc INTEGER NOT NULL)")
    db.executemany("INSERT INTO bai VALUES (?, ?)", [(4, 100), (3, 100), (2, 100), (1, 99)])
    dau = db.execute("SELECT id, moc FROM bai ORDER BY moc DESC, id DESC LIMIT 2").fetchall()
    id_cuoi, moc_cuoi = dau[-1]
    sau = db.execute(
        "SELECT id, moc FROM bai WHERE (moc, id) < (?, ?) ORDER BY moc DESC, id DESC LIMIT 2",
        (moc_cuoi, id_cuoi),
    ).fetchall()
assert [row[0] for row in dau + sau] == [4, 3, 2, 1]
print(dau, sau)