Oil prices will stage a modest recovery in Q4 but additional gains will hinge on OPEC, a CNBC survey showed.