In 1973, a social psychologist from Stanford perpetrated one of the greatest scientific frauds of recent history. Its consequences still resonate today, says Andrew Scull