Not really. 请 or "Please" itself is a polite request. Unless you are instructing a person 坐! or "Sit!". Then it will probably sound rude.
"Please sit" is literal translation. In most Western countries will probably say "Please be seated" or "Please have a seat" , etc. But in Chinese "请坐" is good enough and suitable either casual or formal use.