Crash when disk full on GPKG/MBTiles creation

[Even Rouault]

2 issues :

• OGRSQLiteBaseDataSource::DoTransactionCommand() inappropriately touches nSoftTransactionLevel, whereas it is the responisiblity of calling function to do so
• the GPKG/MBTiles drivers do not check if the COMMIT is successful

[Even Rouault]

In 35566:

SQLite: don't touch nSoftTransactionLevel in DoTransactionCommand() in case of error, since it can cause later CPLAssert() to trigger (fixes #6667)

[Even Rouault]

In 35567:

GPKG/MBTiles: check if transaction COMMIT is succesful (fixes #6667)

[Even Rouault]

In 35568:

SQLite: don't touch nSoftTransactionLevel in DoTransactionCommand() in case of error, since it can cause later CPLAssert() to trigger (fixes #6667)

[Even Rouault]

In 35569:

GPKG/MBTiles: check if transaction COMMIT is succesful (fixes #6667)

[Even Rouault]

In 35589:

GPKG: complementary commit refs #6667

[Even Rouault]

In 35590:

GPKG: complementary commit refs #6667