More than eight in 10 Scots consider England to be their biggest sporting rival, new national research has revealed.