Add functional tests for zmq sequence topic and mempool sequence logic

Summary:
This is a backport of core#19572 [3/4]
https://github.com/bitcoin/bitcoin/pull/19572/commits/68c3c7e1bdd00bbe7d70592a8eb39520fa3f87f1

The main change from the original PR is the removal of the RBF tests.

Depends on D10304

Test Plan: test/functional/test_runner.py interface_zmq

Reviewers: #bitcoin_abc, Fabien

Reviewed By: #bitcoin_abc, Fabien

Subscribers: Fabien

Differential Revision: https://reviews.bitcoinabc.org/D10306