You can only verify double spends if the integrity of the chain is intact. Since its not a decentralized database, and your service can "go down" at any time and "pop up" with amended transaction history, its just the illusion of transparency.
If you know that, and your users know that, why not just keep transactions private like PayPal.
Then you can verify double spends