I have taken Mediterranean cruises in October quite a few times. The average temperatures are what the name says - average temperatures. There can be times where it is consierably warmer as well as times where it is much colder.
It is simply impossible to predict how the weather might be this upcoming October. My suggestion would be to take "warm weather clothes" as well as jeans (or similar) and a couple of sweaters or so per person.