Synchronize Ogmios state with Blockfrost when run-your-own Blockfrost is in use

[klntsky]

We introduced confirmTxDelay in Blockfrost to adjust for concurrency problems between Ogmios and Blockfrost - see here for context.

The change was needed, because we were unable to "look into" what Ogmios percieves as current UTxO state.

But with self-hosted Blockfrost, it is possible to simply query Ogmios for current UTxOs and delay execution until they match whatever Blockfrost returns, in a similar manner to #1440.

After #1395 is merged, we can unlock this possibility. One problem though, we use Kupo for getUtxoByOref, and it would be unwise to introduce a runtime dependency just for that. We should fallback to use https://ogmios.dev/mini-protocols/local-state-query/#utxo-by-txin , which means implementing one more Ogmios endpoint.

This task should be delayed until we confirm that the current approach is unsatisfactory for the clients.