Why does rotation occur?
The scientific explanation is easy: if the sum of all forces is not directly in line with the center of mass of the object, it will rotate, and friction forces are applied at the point of contact.
The more interesting question is how to understand that intuitively.
Consider the case of a soda can rolled along a table. For sake of argument, let's say you push right through the center of the can. So we can look at all of the forces.
- There's you pushing on it from one side.
- There's gravity pulling it down
- There's the table pushing it up (the so called "normal force" which keeps the can from falling through the table)
- Friction
The last one is the key. There's friction between the table and the can. It acts at the point where the can touches the table, resisting the forward motion you are applying to the can. Because this force is not in line with the center of mass of the can, it starts rotating.
We can change this up a bit by pushing on the can a little lower. Now, friction is still opposing us like before, but the force of our hand is also no longer in line with the center of mass. In fact, if we choose just the right point, we can cancel the rotational force caused by friction holding the can back with the rotational force caused by our finger pushing it forward off-center!
This concept is essential in the game of pool. When you strike the cue ball, you strike it in different places to impart rotational motion (spin) to the cue ball. If you strike it dead on center, the friction of the table causes the ball to roll forward. If you strike it slightly below center, you can cause the ball to just slide forward without rotating very much (eventually the table will win, and the ball will start to roll). In fact, you can even strike it far enough below the center to cause the ball to start spinning backwards. This has the neat effect of causing the ball to roll backwards after hitting something!
A few trick shots
It's implicit in Newton's second and third laws together with one crucial assumption.
Consider the simplest system - two point masses linked by a massless infinitely stiff tether. Now impart a force on one and write down the equations of motion for the point masses given the tether. You will find that the system's rotation falls naturally out of the equations.
Indeed, for an arbitrary system of point masses, you can define their total angular momentum about their center of mass and show that the time rate of change of this quantity is indeed given by the nett torque about the center of mass imparted to the system if you assume that the force on particle A from B is equal and opposite to that on B from A and that the forces between the particles always act along the line joining them. This is a specialized case of Euler's second law, and Newton was aware of its holding when the these assumptions hold further to his second law. Indeed, it was thought experimentation along these lines that helped led him to his third law.
So Newton's second and third law together with the assumption of forces along lines joining particles is equivalent to conservation of angular momentum for systems of particles.
Rigid body rotation is simply the special case of the above when the forces between constituent atoms become very large for very small strains, i.e. the body is stiff and can thus only possibly move by Euclidean isometries, i.e. by translation and rotation.