I'll start with the second part of your question:
If the frequency of the force, $\omega$, goes to zero then it is just a constant force - there won't be any oscillation! Since there is no oscillation the force and the motion will be in phase (by default).
To answer why the force and motion can HAVE separate phases in the first place we look at the differential equation that describes the motion. Let $x$ be the displacement of the object about the central (rest) point. For the system you describe we will have:
A restoring force, $F_R$, with equation $$F_R=-kx$$ where $k$ is a positive constant (often called spring constant).
A damping force, $F_D$ proportional to the objects velocity, which takes the form $$F_D=-c\frac{dx}{dt}$$
where $c$ is also a positive constant.
and a driving force, which in your question takes the form
$$F(t)=F_0\cos(\omega t) \, .$$
Applying Newton's second law ($F=ma$):
$$\Sigma F=m\frac{d^2x}{dt^2}\\
\implies F_0\cos(\omega t)-c\frac{dx}{dt}-kx=m\frac{d^2x}{dt^2} \, .$$
Solving this differential equation isn't too hard, and I encourage you to look up the details on solving it. The result is:
$$x(t)=x_0\cos(\omega t+\phi)$$
where $x_0$ and $\phi$ depend on the other parameters given.