First Minister John Swinney has said he is “not sympathetic” to allowing alcohol at football games.