It's possible. CPU power is the largest limiting factor for a proper Civilization game. PS4/XBO have relatively weak CPUs, but they should be capable of playing it albeit with extremely long turn times when you get later into the game.
What I think would be more likely is an updated version of the console Civilization that was released back on X360/PS3.
Regards,
SB