Counting consecutive numbers in a comma-separated list

I tried to find a formula or a macro for this online but I couldn't find anything.

I need a way to calculate the consecutive numbers in a comma separated list.

Please see the attached file for sample data and expected results.

Thanks in advance.

I'm using Excel 2016.

* In the sample file, I put the expected results in separate cells, but it can be in a single too.