如何在每次追加内容时将序列号添加到csv？

import csv

def append_to_csv(filename, content):
    # 打开CSV文件
    with open(filename, 'a', newline='') as file:
        writer = csv.writer(file)
        
        # 读取CSV文件内容
        with open(filename, 'r') as file:
            reader = csv.reader(file)
            rows = list(reader)
        
        # 生成序列号
        serial_number = len(rows) + 1
        
        # 追加内容并添加序列号
        row = [serial_number] + content
        writer.writerow(row)
    
    # 保存CSV文件
    file.close()

# 示例用法
filename = 'data.csv'
content = ['John Doe', 'john.doe@example.com', 'New York']
append_to_csv(filename, content)