Common emitter bandwidth and probing
Nothing fatal with the circuit. It's DC bias is reasonably set, and it will amplify. One problem is no effort to include even a simple representation of a load - any load will reduce gain. Resistors chosen are too high. Many very wideband amplifiers work with 50 ohm sources and 50 ohm loads. They might pull tens of milliamps or more from their DC supply. 800mV input might be a bit high, risking amplifier non-linear behaviour. At 1MHz, 50 ohm impedance at input/output is perhaps overkill, but this amplifier's high impedance will result in providing very little output power.
Probing the transistor collector with a 'scope probe adds capacitance, which combines with the 6.8k collector resistor to form a low-pass filter - which attenuates higher frequencies. You only need a loading capacitance of about 20pf to cause noticeable attenuation at 1 MHz. A 1X 'scope probe might have more than 100pf capacitance. A 10X 'scope probe might have 11pf.

Estimate a resistance (and perhaps capacitance) of your intended load. Add this to your circuit's output, coupled through an appropriate-size capacitor. You will find that gain is adversely affected.
Try scaling amplifier resistors downward, biasing that transistor with more collector current.

If these measures can't produce enough gain @ 1MHz., consider a tuned amplifier, with the 6.8k resistor replaced by an inductor resonated by a parallel capacitor. Doing so may risk making an oscillator, but makes achieving a reasonable power gain easier. Tuning to 1MHz is not particularly easy for a beginner, and coupling power from the collector to a load impedance adds complication too.