The resistor potential divider, consisting of the two 10kΩ resistors, have exactly the same behaviour as this equivalent, shown right:

simulate this circuit – Schematic created using CircuitLab
This is Thévenin's theorem, which you should study to understand this equivalency.
If I replace the divider in your circuit with this equivalent, you get this:

simulate this circuit
You expected this gain \$A\$:
$$ A = 1 + \frac{100k\Omega}{1k\Omega} = 101 $$
Hopefully you see why \$R_{TH}\$ and \$R_4\$ in series produce 6kΩ, and so gain will actually be:
$$ A = 1 + \frac{100k\Omega}{6k\Omega} \approx 18 $$
The divider itself would need a Thévenin equivalent resistance of \$R_{TH}=1k\Omega\$. That's easy, just use \$R_1=R_2=2k\Omega\$:

simulate this circuit
Now you have gain \$A=101\$, but there are still problems.
You expected the signal at \$V_{OUT}\$ to be centered on +6V when the input is \$V_{IN}=0V\$, but that won't happen either. The circuit now considers +6V to be the "center" for both input and output. To this amplifier, an input \$V_{IN}=0V\$ looks very negative with respect to the new +6V centre, and the op-amp would try to produce a very large negative potential. It would fail, of course, because there's no negative supply. That's why you see your output stuck at 0V.
If you tell the op-amp to output a signal centered about +6V, then the input too needs to be centered on +6V. You could adapt the above design to "bias" the input signal about this +6V level, using a capacitor and another resistor divider:

simulate this circuit
This design uses R5 and R6 to bias the signal at Y, so that it is centered at +6V. C1 "AC couples" IN to Y, bridging the potential gap between \$V_{IN}\$ centered at zero, and \$V_Y\$ centered at +6V. Potential changes (AC) at IN will be copied to Y, but the DC levels of IN and Y can be very different, thanks to C1.
This works, but it relies on very precise resistors. The ratio \$R_1:R_2\$ must exactly equal \$R_5:R_6\$. This is difficult to do, and so we generally stick to the oldest biasing technique in the book (for non-inverting arrangements like this):

simulate this circuit
We employ the same input biasing technique at the input, using R5, R6 and C1, but we add C2 to do the same kind of DC offset compensation for the output, allowing \$V_{OUT}\$ to have an offset exactly equal to the average potential at Y. You'll notice that I went back to the original 1kΩ for R4, because C2 takes care of the 6V offset, rendering all that Thévenin stuff unnecessary.