Six people have been taken to hospital after a seven-car pile-up on Cork's main ring road.