What if the net force provided for a circular motion is larger than the required centripetal force? Will an object be pulled towards the centre linearly if the net force provided for a circular motion is larger than the required centripetal force? And why?
For example, if the object in a circular motion which is connected by a string is pulled towards the centre by hand.
 A: When pulled harder towards the centre, it cannot start moving linearly towards the centre.
It already has a tangential speed (otherwise there would be no circular motion). In order to start moving linearly towards the centre, the tangential speed must be zero. If you pull directly inwards, then there is no force acting tangentially, so nothing to slow down the tangential speed.
A: Let's be more exact about this:
Newton's second law for planar motion in polar coordinates is given by
$$\mathbf F=m\left(\ddot r-r\dot\theta^2\right)\hat r+m\left(r\ddot\theta+2\dot r\dot\theta\right)\hat\theta$$
where $r$ is the radial coordinate and $\theta$ is the angle from the $x$-axis.
If we apply only a radially inward force $\mathbf F=-F\,\hat r$, then we end up with two coupled differential equations
$$\ddot r=r\dot\theta^2-\frac Fm$$
$$\ddot\theta=-\frac{2\dot r\dot\theta}{r}$$
Just to check, let's solve this problem for uniform circular motion first. For initial conditions we will use (I will leave off units on my numbers) $r(0)=10$, $\dot r(0)=0$, $\theta(0)=0$, $\dot\theta(0)=1$. Let's set $m=1$. For uniform circular motion, this means that we want $F=mr\dot\theta^2=1\cdot10\cdot1^2=10$. And of course we get uniform circular motiotion, as shown in the x-y plot below

So, now what if we keep our same initial conditions that we had in our uniform circular motion, and we suddenly double our force magnitude from $10$ to $20$? Well, unlike what other (now deleted) answers are saying, we don't get a spiral to the origin. We actually get oscillations in $r$, as shown below:

This makes sense. From a fictitious force perspective, the centrifugal force acting on the object will increase as it moves radially inward, thus there comes a point where the object is pulled outwards rather than inwards. Then the object will eventually move out, then back in, etc.
If we want to get to the center, let's try increasing the force over time. As a first pass, lets make the force magnitude a linearly increasing function of time that starts at our uniform circular motion force. For example, if $F=10\cdot(1+10\cdot t)$ we end up with this trajectory:

where the trajectory can get as close to the origin as you want as the force increases. However, there will still be oscillations in $r$. You will not get a perfect spiral with this type of force.
To gain more insight, let's reverse engineer how to get a spiral. As a simple first step, let's look at a spiral that goes inward with a constant linear radial speed and constant angular speed. This is easily described by the following equations (note that I'm using the variable $v$ here as the "inward speed", not in the usual sense like $v=r\omega$)
$$r(t)=r_0-vt$$
$$\theta(t)=\omega t$$
So we know the force acting on our object is given by
$$\mathbf F=m\left(\ddot r-r\dot\theta^2\right)\hat r+m\left(r\ddot\theta+2\dot r\dot\theta\right)\hat\theta=m\left(0-(r_0-vt)\omega^2\right)\hat r+m\left(0-2v\omega\right)\hat\theta$$
So, we want a force
$$\mathbf F=-m\omega^2(r_0-vt)\,\hat r-2mv\omega\,\hat\theta$$
So, this cannot be done with a string because $F_\theta\neq0$.
We are close though! More realistically, if we are actually pulling on a string by hand then we are likely directly controlling $r(t)$ while having $F_\theta=0$. So let's combine the two classes of scenarios covered above and say $\mathbf F=-F\hat r$ for our string and constrain $r(t)=r_0-vt$ to try and get an inward spiral. Then our equations of motion become
$$0=\dot\theta^2(r_0-vt)-\frac Fm$$
$$\ddot\theta=\frac{2v\dot\theta}{r_0-vt}$$
The second differential equation let's us determine $\dot\theta(t)$ as (notice how angular momentum is conserved, which is a nice sanity check)
$$\dot\theta(t)=\frac{r_0^2\dot\theta(0)}{(r_0-vt)^2}$$
And so the force we need is given by
$$F=m\dot\theta(t)^2(r_0-vt)=\frac{mr_0^4\dot\theta(0)^2}{(r_0-vt)^3}$$
We get a centripetal force that is increasing in magnitude, which is what we wanted. But notice how now it increases as $1/(r_0-vt)^3$ rather than just linearly with respect to $t$. Note that now we can only look at $t<r_0/v$ since crossing $t=r_0/v$ would make an infinite force.

So finally, let's answer your question

Will an object be pulled towards the centre linearly if the net force provided for a circular motion is larger than the required centripetal force? And why?

Assuming by "linearly" you mean with a constant radial speed, then the answer is yes as long as you increase the force in just the right way. This has a simple explanation in the frame rotating with the object: you are supplying just the right amount of force to balance the centrifugal force at all points in time.
