how to find frequency of similar sequences in mysql

suppose that we have a table that contains id's of processes. the id's of processes form sequences like (1-2-4-5-6-10). the process sequence form can vary (it can be 1-2-4-8 or 1-2-4-5-7-8). these sequences repeat frequently. How do we find the frequency of each process sequence form?

the id's are stored in 1 row at a time