Make `BlockchainProvider2` receipt methods aware of in-memory state

[Rjected]

Similar to https://github.com/paradigmxyz/reth/issues/10181, the following methods only fetch from the database and do not check in-memory state: https://github.com/paradigmxyz/reth/blob/a7062066958f45665f41de58d94b1bc5c6d68c57/crates/storage/provider/src/providers/blockchain_provider.rs#L745-L750

https://github.com/paradigmxyz/reth/blob/a7062066958f45665f41de58d94b1bc5c6d68c57/crates/storage/provider/src/providers/blockchain_provider.rs#L702-L704

These should also be updated to be aware of the current in-memory canonical state.