invoices: fix SQL invoice query pagination #14776

Job	Run time
check commits	6m 22s
lint code	7m 16s
RPC and mobile compilation check	5m 42s
cross compilation	28m 46s
sample configuration check	4m 38s
Sqlc check	5m 21s
run unit tests (btcd unit-cover)	17m 5s
check pinned dependencies (google.golang.org/grpc v1.59.0)	6s
run unit tests (unit tags="kvdb_etcd")	18m 43s
run unit tests (unit tags="kvdb_postgres")	18m 13s
check pinned dependencies (github.com/golang/protobuf v1.5.3)	5s
check release notes updated	4s
run unit tests (unit tags="kvdb_sqlite")	16m 33s
run unit tests (btcd unit-race)	34m 34s
run unit tests (unit-module)	4m 15s
run windows itest	40m 39s
run ubuntu itests (btcd, backend=btcd cover=1)	25m 19s
run ubuntu itests (bitcoind, backend=bitcoind cover=1)	34m 20s
run macOS itest	43m 4s
run ubuntu itests (bitcoind-notxindex, backend="bitcoind notxindex")	31m 14s
run ubuntu itests (bitcoind-rpcpolling, backend="bitcoind rpcpolling" cover=1)	33m 14s
run ubuntu itests (bitcoind-etcd, backend=bitcoind dbbackend=etcd)	41m 40s
run ubuntu itests (bitcoind-postgres, backend=bitcoind dbbackend=postgres)	58m 31s
run ubuntu itests (bitcoind-sqlite, backend=bitcoind dbbackend=sqlite)	32m 58s
run ubuntu itests (bitcoind-postgres-nativesql, backend=bitcoind dbbackend=postgres nativesql=true)	1h 0m 30s
run ubuntu itests (bitcoind-sqlite-nativesql, backend=bitcoind dbbackend=sqlite nativesql=true)	33m 30s
run ubuntu itests (neutrino, backend=neutrino cover=1)	31m 38s
finish	3s
	10h 34m 23s

Provide feedback