Coventry climb out of the relegation zone after ending their 25-year wait for a top-flight goal and victory in front of their own fans.