If you are pushing the coin across the table at a constant rate, the friction of the table and the horizontal force of your hand pushing are equal, and the coin itself moves at a constant rate. If you push a coin and let it go, there is no horizontal force keeping the coin going. Friction slows the coin to a stop. In both cases, the gravitational downward pull of Earth is equally but oppositely resisted by the upward push of table on the coin.
Rocket fuel will and smoke will emit from the thrusters.