It is an instinct in cats to hunt and rip their prey, so they rip the paper. However, cats use to mark territory too, so this combination of actions can bring about cats ripping up toilet papers.