It is called the quivering motion of the tail. It happens when the cat is highly thrilled. Cats erect their seats, and the whole length seems to vibrate. It could happen when you offer them treats or meet them after a long time.