Acutally, by the rules, just about anything could climb a normal rope with at least a 30% chance of success since Climb is an untrained skill and climbing a normal rope is DC 15 (a rope created by the rope trick spell is only DC 5).
So by the rules, an elephant, a hippopotamus, a horse, a...